From 2691ef773ba8dc77dd334cab306581d89c0e323f Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Wed, 5 Aug 2026 13:55:27 +0000
Subject: [PATCH] Add example query to AGGRESSIONS doc

---
 doc/src/tables/aggressions.m4 | 44 +++++++++++++++++++++++++++++++----
 1 file changed, 40 insertions(+), 4 deletions(-)

diff --git a/doc/src/tables/aggressions.m4 b/doc/src/tables/aggressions.m4
index 365f3a4..db4b84a 100644
--- a/doc/src/tables/aggressions.m4
+++ b/doc/src/tables/aggressions.m4
@@ -31,10 +31,6 @@ AGGRESSIONS
 
 |AGGRESSIONS_summary|
 
-.. sidebar::
-
-   |DYADS helpful|
-
 When there are multiple individuals, whether aggressor or recipient,
 involved in simultaneous aggressive behavior, there should be multiple
 rows in the AGGRESSIONS table.
@@ -68,6 +64,45 @@ For further information, including additional data integrity rules,
 see the documentation of the :ref:`EVENTS <EVENTS_aggression_code>`
 table.
 
+The |DYADS| view is useful when querying AGGRESSIONS.
+
+.. code-block:: sql
+   :caption: Using DYADS to provide a more complete picture of aggressions
+
+   SELECT dyads.wid, dyads.type
+        , dyads.eid
+        , dyads.actor_pid, dyads.recipient_pid
+        , dyads.date
+        , dyads.animid AS focal
+        , dyads.commid AS followcommid
+        , dyads.start AS time
+        , dyads.certainty
+        , dyads.actor, dyads.recipient
+        , dyads.style
+        , aggressions.decided
+        , aggressions.multiaggressors
+        , aggressions.multirecipients
+        , aggressions.badobs
+        , aggressions.bristle
+        , aggressions.display
+        , aggressions.chase
+        , aggressions.contact
+        , aggressions.vocal
+        , aggressions.severity
+        , aggressions.commid AS aggressionscommid
+        , aggressions.extractedby
+        , dyads.notes
+        , dyads.event_notes
+        , aggressions.aggressorbehavior
+        , aggressions.recipientbehavior
+        , aggressions.fullaccount
+     FROM dyads
+       JOIN aggressions
+            ON (aggressions.eid = dyads.eid)
+     WHERE dyads.behavior = 'sdb_aggression'
+     ORDER BY dyads.actor, dyads.date, dyads.start
+            , dyads.recipient, dyads.eid;
+
 .. sidebar::
 
    The |AGGRESSIONS.AggressorBehavior| and
@@ -78,6 +113,7 @@ table.
    their sources.
 
 
+
 .. contents::
    :depth: 2
 
-- 
2.34.1